Imports DgvFilterPopup

Public Class frm<OwnerU>_<TableU>

    Private cls<Database>Data As New sr<Database>Data.<Database>DataServiceClient
    Private cls<OwnerU>_<TableU>Data As New sr<OwnerU>_<TableU>.I<OwnerU>_<TableU>ServiceClient
    <If Loop>
          <IsFKey>
    Private cls<OwnerU>_<TableU>ComboData As New sr<OwnerU>_<TableU>Combo.I<OwnerU>_<TableU>ComboServiceClient
	    <ExitLoop>
        </If Loop>

    Private bAddMode As Boolean = False
    Private bEditMode As Boolean = False
    Private bDeleteMode As Boolean = False
    Private iRow As Int32 = 0

    Public Property AddMode() As Boolean
        Get
            Return bAddMode
        End Get
        Set(ByVal value As Boolean)
            bAddMode = value
        End Set
    End Property

    Public Property EditMode() As Boolean
        Get
            Return bEditMode
        End Get
        Set(ByVal value As Boolean)
            bEditMode = value
        End Set
    End Property

    Public Property DeleteMode() As Boolean
        Get
            Return bDeleteMode
        End Get
        Set(ByVal value As Boolean)
            bDeleteMode = value
        End Set
    End Property

    Public Property Row() As Int32
        Get
            Return iRow
        End Get
        Set(ByVal value As Int32)
            iRow = value
        End Set
    End Property

    Private Sub frm<OwnerU>_<TableU>_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        <If Loop>
          <IsFKey>
        Load<OwnerU>_<TableU>_<ROwnerU>_<RTableU>ComboBox<MiscTag>()
        </If Loop>
        LoadGridCode()
        ShowToolStripItems("Cancel")
        Dim filterManager As New DgvFilterManager(gridCode)
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    <If Loop>
      <IsFKey>
    Private Sub Load<OwnerU>_<TableU>_<ROwnerU>_<RTableU>ComboBox<MiscTag>()
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        Dim <OwnerU>_<TableU>_<ROwnerU>_<RTableU>List As List(Of sr<OwnerU>_<TableU>Combo.<OwnerU>_<TableU>_<ROwnerU>_<RTableU>Class<MiscTag>)
        Try
            <OwnerU>_<TableU>_<ROwnerU>_<RTableU>List = cls<OwnerU>_<TableU>ComboData.List<OwnerU>_<TableU>_<ROwnerU>_<RTableU><MiscTag>
            <IsFKey>
            cb<FieldU>.DataSource = <OwnerU>_<TableU>_<ROwnerU>_<RTableU>List
            cb<FieldU>.ValueMember = "<RFieldU>"
            cb<FieldU>.DisplayMember = "<RDisplayFieldU>"
        Catch ex As Exception
            MessageBox.Show(ex.Message, ex.GetType.ToString)
        End Try
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    </If Loop>
    Private Sub LoadGridCode()
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        Try
            With gridCode
                .RowHeadersVisible = False
                .DataSource = cls<OwnerU>_<TableU>Data.SelectAll.Tables(0)
                If .Rows.Count = 0 Then
                    ShowToolStripItems("No Record")
                Else
        	<If Loop>
	          <IsMoney>
                    .Columns(<ColNo>).DefaultCellStyle.Format = "c"
		  <IsSmallMoney>
                    .Columns(<ColNo>).DefaultCellStyle.Format = "c"
                  <IsNumber>
                  <And>
                  <IsNotFKey>
                    .Columns(<ColNo>).DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight
        	</If Loop>
                End If
            End With
        Catch
        End Try
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Sub gridCode_Click(sender As Object, e As System.EventArgs) Handles gridCode.Click
        Try
            Row = gridCode.CurrentRow.Index
        Catch
        End Try
    End Sub

    Private Sub gridCode_DoubleClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles gridCode.DoubleClick
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        Try
            If gridCode.Rows.Count > 0 Then
                ShowHideTabPages(TPForm, TPGrid)
                Row = gridCode.CurrentRow.Index
                Edit()
            End If
        Catch
        End Try
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub Add()
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        Me.AddMode = True
        Me.EditMode = False
        Me.DeleteMode = False

        ClearRecord()
        EnableRecord(True)
 -----------------------------------------------------<Comment>
        <If Loop>
           <IsUniqueIdentifier>
           <And>
           <IsTextBox>
        Me.tb<FieldU>.Text = Guid.NewGuid.ToString
           <IsUniqueIdentifier>
           <And>
           <IsMaskedTextBox>
        Me.tb<FieldU>.Text = Guid.NewGuid.ToString
        </If Loop>
 -----------------------------------------------------<Comment>
        <If Loop>
           <IsNotIdentity>
           <And>
           <IsCheckBox>
        cb<FieldU>.Select()
              <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsNumericUpDown> 
        nud<FieldU>.Select()
              <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsDateTimePicker>
        dtp<FieldU>.Select()
              <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsTextBox>
        tb<FieldU>.Select()
              <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsMaskedTextBox>
        mtb<FieldU>.Select()
              <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsMultilineTextBox>
        mtb<FieldU>.Select()
              <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsRichTextBox>
        rtb<FieldU>.Select()
              <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsPictureBox>
        pb<FieldU>.Select()
              <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsComboBox>
        cb<FieldU>.Select()
              <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsComboBox (Db)>
        cb<FieldU>.Select()
              <ExitLoop>
        </If Loop>
-----------------------------------------------------<Comment>
        <If Loop>
           <IsIdentity>
           <And>
           <IsNumericUpDown>
        nud<FieldU>.Value = cls<Database>Data.getAutoID("New", "<Table>")
        </If Loop>

        ShowHideTabPages(TPForm, TPGrid)
        ShowToolStripItems("Add")
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub GetData()
        ClearRecord()

        Dim cls<OwnerU>_<TableU> As New sr<OwnerU>_<TableU>.<OwnerU>_<TableU>Class
        <If Loop>
           <IsPKey>
        cls<OwnerU>_<TableU>.<FieldU> = <Convert>(gridCode.Rows(Row).Cells.Item(<ColNo>).Value)
        </If Loop>
        <If Loop>
           <IsNotPKey>
           <And>
           <IsIdentity>
        cls<OwnerU>_<TableU>.<FieldU> = <Convert>(gridCode.Rows(Row).Cells.Item(<ColNo>).Value)
        </If Loop>
        <If Loop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
        cls<OwnerU>_<TableU>.<FieldU> = <Convert>(gridCode.Rows(Row).Cells.Item(<ColNo>).Value)
           <ExitLoop>
        </If Loop>
        cls<OwnerU>_<TableU> = cls<OwnerU>_<TableU>Data.Select_Record(cls<OwnerU>_<TableU>)

        If Not cls<OwnerU>_<TableU> Is Nothing Then
            Try
                <If Loop>
                   <IsCheckBox>
                   <And>
                   <IsNull>
                cb<FieldU>.Checked = If(cls<OwnerU>_<TableU>.<Field> Is Nothing, Nothing, <Convert>(cls<OwnerU>_<TableU>.<Field>))
                   <IsNumericUpDown>
                   <And>
                   <IsNull>
                nud<FieldU>.Value = If(cls<OwnerU>_<TableU>.<Field> Is Nothing, Nothing, <Convert>(cls<OwnerU>_<TableU>.<Field>))
                   <IsDateTimePicker>
 	           <And>
                   <IsNotDateTimeOffset>
 	           <And>
                   <IsNotTime>
                   <And>
                   <IsNull>
                dtp<FieldU>.Value = If(cls<OwnerU>_<TableU>.<Field> Is Nothing, Date.Now, <Convert>(cls<OwnerU>_<TableU>.<Field>))
                   <IsDateTimePicker>
 	           <And>
                   <IsDateTimeOffset>
 	           <And>
                   <IsNotTime>
                   <And>
                   <IsNull>
                dtp<FieldU>.Value = If(cls<OwnerU>_<TableU>.<Field> Is Nothing, Date.Now, <Convert>(cls<OwnerU>_<TableU>.<Field>.DateTime))
                   <IsDateTimePicker>
 	           <And>
                   <IsNotDateTimeOffset>
 	           <And>
                   <IsTime>
                   <And>
                   <IsNull>
                dtp<FieldU>.Value = If(cls<OwnerU>_<TableU>.<Field> Is Nothing, Date.Now, Convert.ToDateTime(cls<OwnerU>_<TableU>.<Field>.ToString))
                   <IsTextBox>
                   <And>
                   <IsNull>
                tb<FieldU>.Text = If(cls<OwnerU>_<TableU>.<Field> Is Nothing, Nothing, Convert.ToString(cls<OwnerU>_<TableU>.<Field>))
                   <IsMaskedTextBox>
                   <And>
                   <IsNull>
                mtb<FieldU>.Text = If(cls<OwnerU>_<TableU>.<Field> Is Nothing, Nothing, Convert.ToString(cls<OwnerU>_<TableU>.<Field>))
                   <IsMultilineTextBox>
                   <And>
                   <IsNull>
                mtb<FieldU>.Text = If(cls<OwnerU>_<TableU>.<Field> Is Nothing, Nothing, Convert.ToString(cls<OwnerU>_<TableU>.<Field>))
                   <IsRichTextBox>
                   <And>
                   <IsNull>
                rtb<FieldU>.Text = If(cls<OwnerU>_<TableU>.<Field> Is Nothing, Nothing, Convert.ToString(cls<OwnerU>_<TableU>.<Field>))
                   <IsPictureBox>
                   <And>
                   <IsNull>
                pb<FieldU>.Value = If(cls<OwnerU>_<TableU>.<Field> Is Nothing, Nothing, <Convert>(cls<OwnerU>_<TableU>.<Field>))
                   <IsComboBox>
                   <And>
                   <IsNull>
                cb<FieldU>.Text = If(cls<OwnerU>_<TableU>.<Field> Is Nothing, Nothing, Convert.ToString(cls<OwnerU>_<TableU>.<Field>))
                   <IsComboBox (Db)>
                   <And>
                   <IsNull>
                cb<FieldU>.SelectedValue = If(cls<OwnerU>_<TableU>.<Field> Is Nothing, Nothing, <Convert>(cls<OwnerU>_<TableU>.<Field>))
--------------------------------------------------------------------------------------------------------<Comment>
                   <IsCheckBox>
                   <And>
                   <IsNotNull>
                cb<FieldU>.Checked = <Convert>(cls<OwnerU>_<TableU>.<Field>)
                   <IsNumericUpDown>
                   <And>
                   <IsNotNull>
                nud<FieldU>.Value = <Convert>(cls<OwnerU>_<TableU>.<Field>)
                   <IsDateTimePicker>
 	           <And>
                   <IsNotDateTimeOffset>
 	           <And>
                   <IsNotTime>
                   <And>
                   <IsNotNull>
                dtp<FieldU>.Value = <Convert>(cls<OwnerU>_<TableU>.<Field>)
                   <IsDateTimePicker>
 	           <And>
                   <IsDateTimeOffset>
 	           <And>
                   <IsNotTime>
                   <And>
                   <IsNotNull>
                dtp<FieldU>.Value = <Convert>(cls<OwnerU>_<TableU>.<Field>.DateTime)
                   <IsDateTimePicker>
 	           <And>
                   <IsNotDateTimeOffset>
 	           <And>
                   <IsTime>
                   <And>
                   <IsNotNull>
                dtp<FieldU>.Value = Convert.ToDateTime(cls<OwnerU>_<TableU>.<Field>.ToString)
                   <IsTextBox>
                   <And>
                   <IsNotNull>
                tb<FieldU>.Text = Convert.ToString(cls<OwnerU>_<TableU>.<Field>)
                   <IsMaskedTextBox>
                   <And>
                   <IsNotNull>
                mtb<FieldU>.Text = Convert.ToString(cls<OwnerU>_<TableU>.<Field>)
                   <IsMultilineTextBox>
                   <And>
                   <IsNotNull>
                mtb<FieldU>.Text = Convert.ToString(cls<OwnerU>_<TableU>.<Field>)
                   <IsRichTextBox>
                   <And>
                   <IsNotNull>
                rtb<FieldU>.Text = Convert.ToString(cls<OwnerU>_<TableU>.<Field>)
                   <IsPictureBox>
                   <And>
                   <IsNotNull>
                pb<FieldU>.Value = <Convert>(cls<OwnerU>_<TableU>.<Field>)
                   <IsComboBox>
                   <And>
                   <IsNotNull>
                cb<FieldU>.Text = Convert.ToString(cls<OwnerU>_<TableU>.<Field>)
                   <IsComboBox (Db)>
                   <And>
                   <IsNotNull>
                cb<FieldU>.SelectedValue = <Convert>(cls<OwnerU>_<TableU>.<Field>)
                </If Loop>
            Catch
            End Try
        End If
    End Sub

    Private Sub Edit()
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        Me.AddMode = False
        Me.EditMode = True
        Me.DeleteMode = False

        GetData()

        EnableRecord(True)
        <If Loop>
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsNumericUpDown>
        nud<FieldU>.Enabled = False
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsTextBox>
        tb<FieldU>.Enabled = False
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsMaskedTextBox>
        mtb<FieldU>.Enabled = False
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsMultilineTextBox>
        mtb<FieldU>.Enabled = False
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsRichTextBox>
        rtb<FieldU>.Enabled = False
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsComboBox (Db)>
        cb<FieldU>.Enabled = False
           <IsNotIdentity>
           <And>
        </If Loop>
        <If Loop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
           <And>
           <IsNumericUpDown>
        nud<FieldU>.Enabled = False
           <ExitLoop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
           <And>
           <IsTextBox>
        tb<FieldU>.Enabled = False
           <ExitLoop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
           <And>
           <IsMaskedTextBox>
        mtb<FieldU>.Enabled = False
           <ExitLoop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
           <And>
           <IsMultilineTextBox>
        mtb<FieldU>.Enabled = False
           <ExitLoop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
           <And>
           <IsRichTextBox>
        rtb<FieldU>.Enabled = False
           <ExitLoop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
           <And>
           <IsComboBox (Db)>
        cb<FieldU>.Enabled = False
           <ExitLoop>
        </If Loop>
        <If Loop>
           <IsNotIdentity>
           <And>
           <IsNotPKey>
           <And>
           <IsCheckBox>
        cb<FieldU>.Select()
           <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsNotPKey>
           <And>
           <IsNumericUpDown>
        nud<FieldU>.Select()
           <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsNotPKey>
           <And>
           <IsDateTimePicker>
        dtp<FieldU>.Select()
           <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsNotPKey>
           <And>
           <IsTextBox>
        tb<FieldU>.Select()
           <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsNotPKey>
           <And>
           <IsMaskedTextBox>
        mtb<FieldU>.Select()
           <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsNotPKey>
           <And>
           <IsMultilineTextBox>
        mtb<FieldU>.Select()
           <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsNotPKey>
           <And>
           <IsRichTextBox>
        rtb<FieldU>.Select()
           <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsNotPKey>
           <And>
           <IsComboBox>
        cb<FieldU>.Select()
           <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsNotPKey>
           <And>
           <IsComboBox (Db)>
        cb<FieldU>.Select()
           <ExitLoop>
        </If Loop>
-----------------------------------------------------<Comment>

        ShowHideTabPages(TPForm, TPGrid)
        ShowToolStripItems("Edit")
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub Delete()
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        Me.AddMode = False
        Me.EditMode = False
        Me.DeleteMode = True

        GetData()

        EnableRecord(False)
        ShowHideTabPages(TPForm, TPGrid)
        ShowToolStripItems("Delete")
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub EnableRecord(ByVal YesNo As Boolean)
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        <If Loop>
           <IsNotIdentity>
           <And>
           <IsCheckBox>
        Me.cb<FieldU>.Enabled = YesNo
           <IsNotIdentity>
           <And>
           <IsNumericUpDown>
        Me.nud<FieldU>.Enabled = YesNo
           <IsNotIdentity>
           <And>
           <IsDateTimePicker>
        Me.dtp<FieldU>.Enabled = YesNo
           <IsNotIdentity>
           <And>
           <IsTextBox>
        Me.tb<FieldU>.Enabled = YesNo
           <IsNotIdentity>
           <And>
           <IsMaskedTextBox>
        Me.mtb<FieldU>.Enabled = YesNo
           <IsNotIdentity>
           <And>
           <IsMultilineTextBox>
        Me.mtb<FieldU>.Enabled = YesNo
           <IsNotIdentity>
           <And>
           <IsRichTextBox>
        Me.rtb<FieldU>.Enabled = YesNo
           <IsNotIdentity>
           <And>
           <IsPictureBox>
        Me.pb<FieldU>.Enabled = YesNo
           <IsNotIdentity>
           <And>
           <IsComboBox>
        Me.cb<FieldU>.Enabled = YesNo
           <IsNotIdentity>
           <And>
           <IsComboBox (Db)>
        Me.cb<FieldU>.Enabled = YesNo
        </If Loop>
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub ClearRecord()
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        <If Loop>
           <IsCheckBox>
        Me.cb<FieldU>.Text = Nothing
           <IsNumericUpDown>
        Me.nud<FieldU>.Value = 0
           <IsDateTimePicker>
        Me.dtp<FieldU>.Text = Nothing
           <IsTextBox>
        Me.tb<FieldU>.Text = Nothing
           <IsMaskedTextBox>
        Me.mtb<FieldU>.Text = Nothing
           <IsMultilineTextBox>
        Me.mtb<FieldU>.Text = Nothing
           <IsRichTextBox>
        Me.rtb<FieldU>.Text = Nothing
           <IsPictureBox>
        Me.pb<FieldU>.Text = Nothing
           <IsComboBox>
        Me.cb<FieldU>.SelectedIndex = -1
           <IsComboBox (Db)>
        Me.cb<FieldU>.SelectedIndex = -1
        </If Loop>
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub GoBack_To_Grid()
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        Dim gridOK As Boolean = False
        Try
            LoadGridCode()
            ShowToolStripItems("Cancel")
            gridCode.Rows(Row).Selected = True
            gridCode.FirstDisplayedScrollingRowIndex = Row
            gridOK = True
        Catch
            'Hide error message.
        Finally
            If gridOK = False Then
                ''''
                ShowToolStripItems("Cancel")
                ''''
            End If
        End Try
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub butCancel_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles butCancel.Click
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        ShowToolStripItems("Cancel")
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub butClose_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles butClose.Click
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        Me.Close()
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub butApply_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles butApply.Click
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        If Me.AddMode = True Then
            Me.InsertRecord()
        ElseIf Me.EditMode = True Then
            Me.UpdateRecord()
        ElseIf Me.DeleteMode = True Then
            Me.DeleteRecord()
        End If
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub SetData(ByVal cls<OwnerU>_<TableU> As sr<OwnerU>_<TableU>.<OwnerU>_<TableU>Class)
        With cls<OwnerU>_<TableU>
                <If Loop>
                    <IsNotIdentity>
                    <And>
                    <IsCheckBox>
                    <And>
                    <IsNull>
                    <And>
                    <IsNullable>
            .<FieldU> = If(cb<FieldU>.Checked, True, False)
                    <IsNotIdentity>
                    <And>
                    <IsNumericUpDown>
                    <And>
                    <IsNull>
                    <And>
                    <IsNullable>
            .<FieldU> = If(String.IsNullOrEmpty(nud<FieldU>.Text), Nothing, CType(nud<FieldU>.Value, <VBType>?))
                    <IsNotIdentity>
                    <And>
                    <IsDateTimePicker>
                    <And>
                    <IsNull>
                    <And>
                    <IsNullable>
            .<FieldU> = If(String.IsNullOrEmpty(dtp<FieldU>.Text), Nothing, CType(dtp<FieldU>.Text, <VBType>?))
                    <IsNotIdentity>
                    <And>
                    <IsTextBox>
                    <And>
                    <IsNull>
                    <And>
                    <IsNullable>
            .<FieldU> = If(String.IsNullOrEmpty(tb<FieldU>.Text), Nothing, CType(tb<FieldU>.Text, <VBType>?))
                    <IsNotIdentity>
                    <And>
                    <IsMaskedTextBox>
                    <And>
                    <IsNull>
                    <And>
                    <IsNullable>
            .<FieldU> = If(String.IsNullOrEmpty(mtb<FieldU>.Text), Nothing, CType(mtb<FieldU>.Text, <VBType>?))
                    <IsNotIdentity>
                    <And>
                    <IsMultilineTextBox>
                    <And>
                    <IsNull>
                    <And>
                    <IsNullable>
            .<FieldU> = If(String.IsNullOrEmpty(mtb<FieldU>.Text), Nothing, CType(mtb<FieldU>.Text, <VBType>?))
                    <IsNotIdentity>
                    <And>
                    <IsRichTextBox>
                    <And>
                    <IsNull>
                    <And>
                    <IsNullable>
            .<FieldU> = If(String.IsNullOrEmpty(rtb<FieldU>.Text), Nothing, CType(rtb<FieldU>.Text, <VBType>?))
                    <IsNotIdentity>
                    <And>
                    <IsPictureBox>
                    <And>
                    <IsNull>
                    <And>
                    <IsNullable>
                          
                    <IsNotIdentity>
                    <And>
                    <IsComboBox>
                    <And>
                    <IsNull>
                    <And>
                    <IsNullable>
            .<FieldU> = <Convert>(cb<FieldU>.Text)
                    <IsNotIdentity>
                    <And>
                    <IsComboBox (Db)>
                    <And>
                    <IsNull>
                    <And>
                    <IsNullable>
            .<FieldU> = If(String.IsNullOrEmpty(cb<FieldU>.SelectedValue.ToString), Nothing, CType(cb<FieldU>.SelectedValue, <VBType>?))
--------------------------------------------------------------------------------------------------------<Comment>
                    <IsNotIdentity>
                    <And>
                    <IsCheckBox>
                    <And>
                    <IsNull>
                    <And>
                    <IsNotNullable>
            .<FieldU> = If(cb<FieldU>.Checked, True, False)
                    <IsNotIdentity>
                    <And>
                    <IsNumericUpDown>
                    <And>
                    <IsNull>
                    <And>
                    <IsNotNullable>
            .<FieldU> = If(String.IsNullOrEmpty(nud<FieldU>.Text), Nothing, CType(nud<FieldU>.Value, <VBType>?))
                    <IsNotIdentity>
                    <And>
                    <IsDateTimePicker>
                    <And>
                    <IsNull>
                    <And>
                    <IsNotNullable>
            .<FieldU> = If(String.IsNullOrEmpty(dtp<FieldU>.Text), Nothing, CType(dtp<FieldU>.Text, <VBType>?))
                    <IsNotIdentity>
                    <And>
                    <IsTextBox>
                    <And>
                    <IsNull>
                    <And>
                    <IsNotNullable>
            .<FieldU> = If(String.IsNullOrEmpty(tb<FieldU>.Text), Nothing, tb<FieldU>.Text)
                    <IsNotIdentity>
                    <And>
                    <IsMaskedTextBox>
                    <And>
                    <IsNull>
                    <And>
                    <IsNotNullable>
            .<FieldU> = If(String.IsNullOrEmpty(mtb<FieldU>.Text), Nothing, mtb<FieldU>.Text)
                    <IsNotIdentity>
                    <And>
                    <IsMultilineTextBox>
                    <And>
                    <IsNull>
                    <And>
                    <IsNotNullable>
            .<FieldU> = If(String.IsNullOrEmpty(mtb<FieldU>.Text), Nothing, mtb<FieldU>.Text)
                    <IsNotIdentity>
                    <And>
                    <IsRichTextBox>
                    <And>
                    <IsNull>
                    <And>
                    <IsNotNullable>
            .<FieldU> = If(String.IsNullOrEmpty(rtb<FieldU>.Text), Nothing, rtb<FieldU>.Text)
                    <IsNotIdentity>
                    <And>
                    <IsPictureBox>
                    <And>
                    <IsNull>
                    <And>
                    <IsNotNullable>
                          
                    <IsNotIdentity>
                    <And>
                    <IsComboBox>
                    <And>
                    <IsNull>
                    <And>
                    <IsNotNullable>
            .<FieldU> = <Convert>(cb<FieldU>.Text)
                    <IsNotIdentity>
                    <And>
                    <IsComboBox (Db)>
                    <And>
                    <IsNull>
                    <And>
                    <IsNotNullable>
            .<FieldU> = If(String.IsNullOrEmpty(cb<FieldU>.SelectedValue.ToString), Nothing, cb<FieldU>.SelectedValue.ToString)
--------------------------------------------------------------------------------------------------------<Comment>
                    <IsNotIdentity>
                    <And>
                    <IsCheckBox>
                    <And>
                    <IsNotNull>
            .<FieldU> = <Convert>(IIf(cb<FieldU>.Checked, True, False))
                    <IsNotIdentity>
                    <And>
                    <IsNumericUpDown>
                    <And>
                    <IsNotNull>
            .<FieldU> = <Convert>(nud<FieldU>.Value)
                    <IsNotIdentity>
                    <And>
                    <IsDateTimePicker>
                    <And>
                    <IsNotNull>
            .<FieldU> = <Convert>(dtp<FieldU>.Value)
                    <IsNotIdentity>
                    <And>
                    <IsTextBox>
                    <And>
                    <IsNotNull>
            .<FieldU> = <Convert>(tb<FieldU>.Text)
                    <IsNotIdentity>
                    <And>
                    <IsMaskedTextBox>
                    <And>
                    <IsNotNull>
            .<FieldU> = <Convert>(mtb<FieldU>.Text)
                    <IsNotIdentity>
                    <And>
                    <IsMultilineTextBox>
                    <And>
                    <IsNotNull>
            .<FieldU> = <Convert>(mtb<FieldU>.Text)
                    <IsNotIdentity>
                    <And>
                    <IsRichTextBox>
                    <And>
                    <IsNotNull>
            .<FieldU> = <Convert>(rtb<FieldU>.Text)
                    <IsNotIdentity>
                    <And>
                    <IsPictureBox>
                    <And>
                    <IsNotNull>
                          
                    <IsNotIdentity>
                    <And>
                    <IsComboBox>
                    <And>
                    <IsNotNull>
            .<FieldU> = <Convert>(cb<FieldU>.Text)
                    <IsNotIdentity>
                    <And>
                    <IsComboBox (Db)>
                    <And>
                    <IsNotNull>
            .<FieldU> = <Convert>(cb<FieldU>.SelectedValue)
--------------------------------------------------------------------------------------------------------<Comment>
                </If Loop>
        End With
    End Sub

    Private Sub InsertRecord()
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        Dim cls<OwnerU>_<TableU> As New sr<OwnerU>_<TableU>.<OwnerU>_<TableU>Class
        If VerifyData() = True Then
            SetData(cls<OwnerU>_<TableU>)
            Dim bSucess As Boolean
            bSucess = cls<OwnerU>_<TableU>Data.Add(cls<OwnerU>_<TableU>)
            If bSucess = True Then
                GoBack_To_Grid()
            Else
                MsgBox("Insert failed.", MsgBoxStyle.OkOnly, "Error")
            End If
        End If
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub UpdateRecord()
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        Dim ocls<OwnerU>_<TableU> As New sr<OwnerU>_<TableU>.<OwnerU>_<TableU>Class
        Dim cls<OwnerU>_<TableU> As New sr<OwnerU>_<TableU>.<OwnerU>_<TableU>Class

        <If Loop>
           <IsPKey>
        ocls<OwnerU>_<TableU>.<FieldU> = <Convert>(gridCode.Rows(Row).Cells.Item(<ColNo>).Value)
        </If Loop>
        <If Loop>
           <IsNotPKey>
           <And>
           <IsIdentity>
        ocls<OwnerU>_<TableU>.<FieldU> = <Convert>(gridCode.Rows(Row).Cells.Item(<ColNo>).Value)
        </If Loop>
        <If Loop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
        ocls<OwnerU>_<TableU>.<FieldU> = <Convert>(gridCode.Rows(Row).Cells.Item(<ColNo>).Value)
           <ExitLoop>
        </If Loop>
        ocls<OwnerU>_<TableU> = cls<OwnerU>_<TableU>Data.Select_Record(ocls<OwnerU>_<TableU>)

        If VerifyData() = True Then
            SetData(cls<OwnerU>_<TableU>)
            Dim bSucess As Boolean
            bSucess = cls<OwnerU>_<TableU>Data.Update(ocls<OwnerU>_<TableU>, cls<OwnerU>_<TableU>)
            If bSucess = True Then
                GoBack_To_Grid()
            Else
                MsgBox("Update failed.", MsgBoxStyle.OkOnly, "Error")
            End If
        End If
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub DeleteRecord()
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        Dim cls<OwnerU>_<TableU> As New sr<OwnerU>_<TableU>.<OwnerU>_<TableU>Class
        <If Loop>
           <IsPKey>
        cls<OwnerU>_<TableU>.<FieldU> = <Convert>(gridCode.Rows(Row).Cells.Item(<ColNo>).Value)
        </If Loop>
        <If Loop>
           <IsNotPKey>
           <And>
           <IsIdentity>
        cls<OwnerU>_<TableU>.<FieldU> = <Convert>(gridCode.Rows(Row).Cells.Item(<ColNo>).Value)
        </If Loop>
        <If Loop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
        cls<OwnerU>_<TableU>.<FieldU> = <Convert>(gridCode.Rows(Row).Cells.Item(<ColNo>).Value)
           <ExitLoop>
        </If Loop>
        Dim result As DialogResult = MessageBox.Show("Are you sure? Delete this record?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question)
        If result = Windows.Forms.DialogResult.Yes Then
            SetData(cls<OwnerU>_<TableU>)
            Dim bSucess As Boolean
            bSucess = cls<OwnerU>_<TableU>Data.Delete(cls<OwnerU>_<TableU>)
            If bSucess = True Then
                GoBack_To_Grid()
            Else
                MsgBox("Delete failed.", MsgBoxStyle.OkOnly, "Error")
            End If
        End If
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Function VerifyData() As Boolean
        <If Loop>
           <IsNotIdentity>
           <And>
           <IsNotNull>
           <And>
           <IsCheckBox>
          
           <IsNotIdentity>
           <And>
           <IsNotNull>
           <And>
           <IsNumericUpDown>
        If nud<FieldU>.Text = "" Then
            MsgBox("<FieldC> is Required", MsgBoxStyle.OkOnly, "Entry Error")
            nud<FieldU>.Select()
            Return False
        End If
           <IsNotIdentity>
           <And>
           <IsNotNull>
           <And>
           <IsDateTimePicker>
        
           <IsNotIdentity>
           <And>
           <IsNotNull>
           <And>
           <IsTextBox>
        If tb<FieldU>.Text = "" Then
            MsgBox("<FieldC> is Required", MsgBoxStyle.OkOnly, "Entry Error")
            tb<FieldU>.Select()
            Return False
        End If
           <IsNotIdentity>
           <And>
           <IsNotNull>
           <And>
           <IsMaskedTextBox>
        If mtb<FieldU>.Text = "" Then
            MsgBox("<FieldC> is Required", MsgBoxStyle.OkOnly, "Entry Error")
            mtb<FieldU>.Select()
            Return False
        End If
           <IsNotIdentity>
           <And>
           <IsNotNull>
           <And>
           <IsMultilineTextBox>
        If mtb<FieldU>.Text = "" Then
            MsgBox("<FieldC> is Required", MsgBoxStyle.OkOnly, "Entry Error")
            mtb<FieldU>.Select()
            Return False
        End If
           <IsNotIdentity>
           <And>
           <IsNotNull>
           <And>
           <IsRichTextBox>
        If rtb<FieldU>.Text = "" Then
            MsgBox("<FieldC> is Required", MsgBoxStyle.OkOnly, "Entry Error")
            rtb<FieldU>.Select()
            Return False
        End If
           <IsNotIdentity>
           <And>
           <IsNotNull>
           <And>
           <IsPictureBox>
        
           <IsNotIdentity>
           <And>
           <IsNotNull>
           <And>
           <IsComboBox>
        If cb<FieldU>.SelectedIndex = -1 Then
            MsgBox("<FieldC> is Required", MsgBoxStyle.OkOnly, "Entry Error")
            cb<FieldU>.Select()
            Return False
        End If
           <IsNotIdentity>
           <And>
           <IsNotNull>
           <And>
           <IsComboBox (Db)>
        If cb<FieldU>.SelectedIndex = -1 Then
            MsgBox("<FieldC> is Required", MsgBoxStyle.OkOnly, "Entry Error")
            cb<FieldU>.Select()
            Return False
        End If         
      </If Loop>
---------------------------------------<Comment>
        <If Loop>
           <IsNotIdentityCount>
        If _
           <ExitLoop>
        </If Loop>
        <If Loop>
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsNumericUpDown>
            nud<FieldU>.Text <> "" _
           <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsTextBox>
            tb<FieldU>.Text <> "" _
           <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsMaskedTextBox>
            mtb<FieldU>.Text <> "" _
           <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsMultilineTextBox>
            mtb<FieldU>.Text <> "" _
           <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsRichTextBox>
            rtb<FieldU>.Text <> "" _
           <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsComboBox (Db)>
             cb<FieldU>.SelectedIndex <> -1 _
           <ExitLoop>
        </If Loop>
        <If Loop>
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsNumericUpDown>
           <And>
           <IsCurRow<>[0]>
            And nud<FieldU>.Text <> "" _
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsTextBox>
           <And>
           <IsCurRow<>[0]>
            And tb<FieldU>.Text <> "" _
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsMaskedTextBox>
           <And>
           <IsCurRow<>[0]>
            And mtb<FieldU>.Text <> "" _
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsMultilineTextBox>
           <And>
           <IsCurRow<>[0]>
            And mtb<FieldU>.Text <> "" _
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsRichTextBox>
           <And>
           <IsCurRow<>[0]>
            And rtb<FieldU>.Text <> "" _
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsComboBox (Db)>
           <And>
           <IsCurRow<>[0]>
             And cb<FieldU>.SelectedIndex <> -1 _
        </If Loop>
        <If Loop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
           <And>
           <IsNumericUpDown>
             nud<FieldU>.Text <> "" _
           <ExitLoop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
           <And>
           <IsTextBox>
             tb<FieldU>.Text <> "" _
           <ExitLoop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
           <And>
           <IsMaskedTextBox>
             mtb<FieldU>.Text <> "" _
           <ExitLoop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
           <And>
           <IsMultilineTextBox>
             mtb<FieldU>.Text <> "" _
           <ExitLoop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
           <And>
           <IsRichTextBox>
             rtb<FieldU>.Text <> "" _
           <ExitLoop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
           <And>
           <IsComboBox (Db)>
             cb<FieldU>.SelectedIndex <> -1 _
           <ExitLoop>
        </If Loop>
        <If Loop>
           <IsNotIdentityCount>
             Then  
             Dim cls<OwnerU>_<TableU> As New sr<OwnerU>_<TableU>.<OwnerU>_<TableU>Class
           <ExitLoop>
        </If Loop>
        <If Loop>
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsNumericUpDown>
             cls<OwnerU>_<TableU>.<FieldU> = <Convert>(nud<FieldU>.Value)
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsTextBox>
             cls<OwnerU>_<TableU>.<FieldU> = <Convert>(tb<FieldU>.Text)
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsMaskedTextBox>
             cls<OwnerU>_<TableU>.<FieldU> = <Convert>(mtb<FieldU>.Text)
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsMultilineTextBox>
             cls<OwnerU>_<TableU>.<FieldU> = <Convert>(mtb<FieldU>.Text)
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsRichTextBox>
             cls<OwnerU>_<TableU>.<FieldU> = <Convert>(rtb<FieldU>.Text)
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsComboBox (Db)>
             cls<OwnerU>_<TableU>.<FieldU> = <Convert>(cb<FieldU>.SelectedValue)
        </If Loop>
        <If Loop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
           <And>
           <IsNumericUpDown>
             cls<OwnerU>_<TableU>.<FieldU> = <Convert>(nud<FieldU>.Value)
           <ExitLoop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
           <And>
           <IsTextBox>
             cls<OwnerU>_<TableU>.<FieldU> = <Convert>(tb<FieldU>.Text)
           <ExitLoop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
           <And>
           <IsMaskedTextBox>
             cls<OwnerU>_<TableU>.<FieldU> = <Convert>(mtb<FieldU>.Text)
           <ExitLoop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
           <And>
           <IsMultilineTextBox>
             cls<OwnerU>_<TableU>.<FieldU> = <Convert>(mtb<FieldU>.Text)
           <ExitLoop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
           <And>
           <IsRichTextBox>
             cls<OwnerU>_<TableU>.<FieldU> = <Convert>(rtb<FieldU>.Text)
           <ExitLoop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
           <And>
           <IsComboBox (Db)>
             cls<OwnerU>_<TableU>.<FieldU> = <Convert>(cb<FieldU>.SelectedValue)
           <ExitLoop>
        </If Loop>
        <If Loop>
           <IsNotIdentityCount>
             cls<OwnerU>_<TableU> = cls<OwnerU>_<TableU>Data.Select_Record(cls<OwnerU>_<TableU>)
             If Not cls<OwnerU>_<TableU> Is Nothing And Me.AddMode = True Then
                  MsgBox("Record already exists", MsgBoxStyle.OkOnly, "Entry Error")
           <ExitLoop>
        </If Loop>
        <If Loop>
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsNumericUpDown>
                  nud<FieldU>.Select()
           <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsTextBox>
                  tb<FieldU>.Select()
           <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsMaskedTextBox>
                  mtb<FieldU>.Select()
           <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsMultilineTextBox>
                  mtb<FieldU>.Select()
           <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsRichTextBox>
                  rtb<FieldU>.Select()
           <ExitLoop>
           <IsNotIdentity>
           <And>
           <IsPKey>
           <And>
           <IsComboBox (Db)>
                  cb<FieldU>.Select()
           <ExitLoop>
        </If Loop>
        <If Loop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
           <And>
           <IsNumericUpDown>
                  nud<FieldU>.Select()
           <ExitLoop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
           <And>
           <IsTextBox>
                  tb<FieldU>.Select()
           <ExitLoop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
           <And>
           <IsMaskedTextBox>
                  mtb<FieldU>.Select()
           <ExitLoop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
           <And>
           <IsMultilineTextBox>
                  mtb<FieldU>.Select()
           <ExitLoop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
           <And>
           <IsRichTextBox>
                  rtb<FieldU>.Select()
           <ExitLoop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
           <And>
           <IsComboBox (Db)>
                  cb<FieldU>.Select()
           <ExitLoop>
        </If Loop>
        <If Loop>
           <IsNotIdentityCount>
                  Return False
             End If
           <ExitLoop>
        </If Loop>
        <If Loop>
           <IsNotIdentityCount>
        End If
           <ExitLoop>
        </If Loop>
---------------------------------------<Comment>
        Return True
    End Function

    Private Sub ShowToolStripItems(ByVal Item As String)
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        bAdd.Enabled = False
        bEdit.Enabled = False
        bDelete.Enabled = False
        bCancel.Enabled = False
        bRefresh.Enabled = False
        Select Case Item
            Case "Add"
                bCancel.Enabled = True
            Case "Edit"
                bCancel.Enabled = True
            Case "Delete"
                bCancel.Enabled = True
            Case "Cancel"
                If gridCode.Rows.Count = 0 Then
                    ShowToolStripItems("No Record")
                Else
                    bAdd.Enabled = True
                    bEdit.Enabled = True
                    bDelete.Enabled = True
                    bRefresh.Enabled = True
                    ShowHideTabPages(TPGrid, TPForm)
                End If
            Case "Refresh"
                bAdd.Enabled = True
                bEdit.Enabled = True
                bDelete.Enabled = True
                bRefresh.Enabled = True
                LoadGridCode()
            Case "No Record"
                bAdd.Enabled = True
                ShowHideTabPages(TPGrid, TPForm)
        End Select
        TPForm.Text = Item.Trim
        TPGrid.Text = "<Owner>.<Table>"
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub ShowHideTabPages(ByVal Show As TabPage, ByVal Hide As TabPage)
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        ''If TC.TabPages.Contains(Hide) Then
        ''    TC.TabPages.Remove(Hide)
        ''End If
        ''If TC.TabPages.Contains(Show) Then
        ''    TC.TabPages.Remove(Show)
        ''End If
        ''If Not TC.TabPages.Contains(Show) Then
        ''    TC.TabPages.Add(Show)
        ''End If

        TC.ItemSize = New Size(0, 1)
        TC.Appearance = TabAppearance.FlatButtons
        TC.SelectedTab = Show
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub TS_ItemClicked(ByVal sender As Object, ByVal e As System.Windows.Forms.ToolStripItemClickedEventArgs) Handles TS.ItemClicked
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        If e.ClickedItem.Text <> "Export" Then
            ShowToolStripItems(e.ClickedItem.Text)
            TPForm.Text = e.ClickedItem.Text.Trim
        End If
        Select Case e.ClickedItem.Text
            Case "Add"
                ShowHideTabPages(TPForm, TPGrid)
                Add()
            Case "Edit"
                ShowHideTabPages(TPForm, TPGrid)
                Edit()
            Case "Delete"
                ShowHideTabPages(TPForm, TPGrid)
                Delete()
            Case "Cancel"
                ShowToolStripItems("Cancel")
            Case "Refresh"
                GoBack_To_Grid()
        End Select
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub bWord_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles bWord.Click
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        If TC.SelectedTab Is TPForm Then
            Library.ExportToWord("One", Me.Text, gridCode)
        ElseIf TC.SelectedTab Is TPGrid Then
            Library.ExportToWord("Many", Me.Text, gridCode)
        End If
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub bExcel_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles bExcel.Click
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        If TC.SelectedTab Is TPForm Then
            Library.ExportToExcel("One", Me.Text, gridCode)
        ElseIf TC.SelectedTab Is TPGrid Then
            Library.ExportToExcel("Many", Me.Text, gridCode)
        End If
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub bPDF_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles bPDF.Click
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        If TC.SelectedTab Is TPForm Then
            Library.ExportToPDF("One", Me.Text, gridCode, gridCode.CurrentRow)
        ElseIf TC.SelectedTab Is TPGrid Then
            Library.ExportToPDF("Many", Me.Text, gridCode, gridCode.CurrentRow)
        End If
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

        <If Loop>
           <IsNotIdentity>
           <And>
           <IsFieldD>
           <And>
           <IsCheckBox>
    Private Sub cb<FieldU>_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles cb<FieldU>.GotFocus
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        SSLabel.Text = "<FieldD>"
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub cb<FieldU>_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles cb<FieldU>.LostFocus
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        SSLabel.Text = Nothing
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub
           <IsNotIdentity>
           <And>
           <IsFieldD>
           <And>
           <IsNumericUpDown>
    Private Sub nud<FieldU>_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles nud<FieldU>.GotFocus
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        SSLabel.Text = "<FieldD>"
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub nud<FieldU>_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles nud<FieldU>.LostFocus
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        SSLabel.Text = Nothing
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub
           <IsNotIdentity>
           <And>
           <IsFieldD>
           <And>
           <IsDateTimePicker>
    Private Sub dtp<FieldU>_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles dtp<FieldU>.GotFocus
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        SSLabel.Text = "<FieldD>"
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub dtp<FieldU>_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles dtp<FieldU>.LostFocus
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        SSLabel.Text = Nothing
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub
           <IsNotIdentity>
           <And>
           <IsFieldD>
           <And>
           <IsTextBox>
    Private Sub tb<FieldU>_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles tb<FieldU>.GotFocus
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        SSLabel.Text = "<FieldD>"
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub tb<FieldU>_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles tb<FieldU>.LostFocus
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        SSLabel.Text = Nothing
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub
           <IsNotIdentity>
           <And>
           <IsFieldD>
           <And>
           <IsMaskedTextBox>
    Private Sub mtb<FieldU>_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles mtb<FieldU>.GotFocus
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        SSLabel.Text = "<FieldD>"
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub mtb<FieldU>_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles mtb<FieldU>.LostFocus
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        SSLabel.Text = Nothing
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub
           <IsNotIdentity>
           <And>
           <IsFieldD>
           <And>
           <IsMultilineTextBox>
    Private Sub mtb<FieldU>_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles mtb<FieldU>.GotFocus
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        SSLabel.Text = "<FieldD>"
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub mtb<FieldU>_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles mtb<FieldU>.LostFocus
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        SSLabel.Text = Nothing
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub
           <IsNotIdentity>
           <And>
           <IsFieldD>
           <And>
           <IsRichTextBox>
    Private Sub rtb<FieldU>_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles rtb<FieldU>.GotFocus
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        SSLabel.Text = "<FieldD>"
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub rtb<FieldU>_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles rtb<FieldU>.LostFocus
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        SSLabel.Text = Nothing
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub
           <IsNotIdentity>
           <And>
           <IsFieldD>
           <And>
           <IsPictureBox>
    Private Sub pb<FieldU>_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles pb<FieldU>.GotFocus
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        SSLabel.Text = "<FieldD>"
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub pb<FieldU>_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles pb<FieldU>.LostFocus
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        SSLabel.Text = Nothing
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub
           <IsNotIdentity>
           <And>
           <IsFieldD>
           <And>
           <IsComboBox>
    Private Sub cb<FieldU>_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles cb<FieldU>.GotFocus
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        SSLabel.Text = "<FieldD>"
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub cb<FieldU>_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles cb<FieldU>.LostFocus
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        SSLabel.Text = Nothing
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub
           <IsNotIdentity>
           <And>
           <IsFieldD>
           <And>
           <IsComboBox (Db)>
    Private Sub cb<FieldU>_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles cb<FieldU>.GotFocus
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        SSLabel.Text = "<FieldD>"
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub cb<FieldU>_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles cb<FieldU>.LostFocus
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        SSLabel.Text = Nothing
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub
        </If Loop>

End Class

